﻿<?xml version="1.0" encoding="utf-8"?>
<queries>
  <query key="DeleteSmartSettingsFromDocflowParams">
    <mssql><![CDATA[if exists
    (select * from dbo.Sungero_Docflow_Params params where params.[Key] = 'ArioUrl')
begin
 delete from dbo.Sungero_Docflow_Params where dbo.Sungero_Docflow_Params.[Key] = 'ArioUrl'
end

if exists
    (select * from dbo.Sungero_Docflow_Params params where params.[Key] = 'MinFactProbability')
begin
 delete from dbo.Sungero_Docflow_Params where dbo.Sungero_Docflow_Params.[Key] = 'MinFactProbability'
end

if exists
    (select * from dbo.Sungero_Docflow_Params params where params.[Key] = 'TrustedFactProbability')
begin
 delete from dbo.Sungero_Docflow_Params where dbo.Sungero_Docflow_Params.[Key] = 'TrustedFactProbability'
end]]></mssql>
    <postgres><![CDATA[do $$
begin

if (exists
   (select * from Sungero_Docflow_Params params where params.Key = 'ArioUrl'))
then
delete from Sungero_Docflow_Params where Sungero_Docflow_Params.Key = 'ArioUrl';
end if;

if (exists
   (select * from Sungero_Docflow_Params params where params.Key = 'MinFactProbability'))
then
delete from Sungero_Docflow_Params where Sungero_Docflow_Params.Key = 'MinFactProbability';
end if;

if (exists
   (select * from Sungero_Docflow_Params params where params.Key = 'TrustedFactProbability'))
then
delete from Sungero_Docflow_Params where Sungero_Docflow_Params.Key = 'TrustedFactProbability';
end if;
end $$]]></postgres>
  </query>
</queries>